home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
BMUG Revelations
/
BMUG Revelations.toast
/
Business
/
Random
/
Optima
/
Best Answer™ Demo
/
Best Answer™ Demo.rsrc
/
STR#_5005.txt
< prev
next >
Wrap
Text File
|
1989-05-31
|
4KB
|
185 lines
______________________________________________
Choose "Maximize" or "Minimize" from the Optimization menu.
To OPTIMIZE:
______________________________________________
"Best Answer".
CONSTRAINTS, by calculating your ADJUSTABLES to attain the
Best Answer‚Ñ¢ will OPTIMIZE your OBJECTIVE, within the given
OPTIMIZATION -- This is the final step!
______________________________________________
(see "Linearity" on the HELP menu).
REMEMBER: Your OBJECTIVE cell must be a linear formula.
2) Choose "Define Objective" from the Cell menu.
1) Select the cell you want to define as the OBJECTIVE cell.
To define the OBJECTIVE cell:
______________________________________________
the value of any CONSTRAINT cell to become negative.
the best possible answer for the OBJECTIVE cell, but does not allow
determine the combination of ADJUSTABLE cell values that yield
mization) or cost cells (for minimization). Best Answer‚Ñ¢ will
Typical examples of OBJECTIVE cells are profit cells (for maxi-
the value that you would like to OPTIMIZE (maximize or minimize).
OBJECTIVE cell -- The OBJECTIVE cell is the cell that contains
______________________________________________
(see "Linearity" on the HELP menu).
REMEMBER: All CONSTRAINT cells must contain linear formulas
2) Choose "Define Constraints" from the Cell menu.
cells in the demo version).
You may define up to 250 CONSTRAINT cells (8 CONSTRAINT
1) Select the cells you want to define as CONSTRAINT cells.
To define CONSTRAINT cells:
______________________________________________
About Constraint Cells" on the HELP menu.
read more about how to do this by referring to "More
Note: You set up CONSTRAINT cells from within Excel. You can
defined restrictions.
When you OPTIMIZE, Best Answer‚Ñ¢ will not violate any of the
cannot go below zero.
This is the cell that you will define as a CONSTRAINT cell; it
=B3-B4
create a new cell in the spreadsheet with the formula:
tory used is less than (or equal to) "inventory in stock", you would
"inventory used" cell (B4), and you want to make sure that inven-
For example, if you have an "inventory in stock" cell (B3) and an
negative when the restrictions are broken.
whose values are positive when the restrictions are met and
Best Answer‚Ñ¢ expects CONSTRAINT cells to be linear formulas
money (you cannot use more money than you have in the kitty).
(you cannot run your production more than 24 hours per day), or
inventory (you cannot use more inventory than you have), time
representing some kind of restricting condition. This might be
CONSTRAINT cells -- These are the cells that contain a formula
______________________________________________
2) Choose "Define Adjustables" from the Cell menu.
Excel).
1) Select the appropriate cells (just like you select cells in
To define ADJUSTABLE cells:
______________________________________________
values; they may not contain formulas or text.
in the demo version). All ADJUSTABLE cells must contain numeric
You can define up to 250 ADJUSTABLE cells (5 ADJUSTABLE cells
values of the ADJUSTABLES) when you OPTIMIZE your spreadsheet.
through "What if...". Best Answer‚Ñ¢ calculates these variables (the
manipulate if you were attempting to reach the optimal solution
contain the variables of the model. These are the cells you would
ADJUSTABLE cells -- The ADJUSTABLE cells are the cells that